EMT Practice Test

1. Question Content...

---

Question1: Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Question2: True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Question3: Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)
Choose 2 answers

Question4: True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

Question5: True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

Question6: What are the three layers that make up Snowflake's architecture? Choose 3 answer

Question7: Which statement best describes Snowflake tables?

Question8: On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers

Question9: True or False: Snowflake charges a premium for storing semi-structured data.

Question10: Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Question11: Which of the following commands sets the Virtual Warehouse for a session?

Question12: In which layer of its architecture does Snowflake store its metadata statistics?

Question13: True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

Question14: Which type of table corresponds to a single Snowflake session?

Question15: The PUT command: (Choose two.)

Question16: The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Question17: Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

Question18: True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

Question19: What is the maximum compressed row size in Snowflake?

Question20: What is the recommended Snowflake data type to store semi-structured data like JSON?

Question21: Which statements are true of micro-partitions? Choose 2 answers

Question22: True or False the longer the data retention period, the higher the resulting storage costs.

Question23: Which of the following are options when creating a Virtual Warehouse?

Question24: Which statement best describes '' clustering''?

Question25: Select the three types of tables that exist within Snowflake.
Choose 3 answers

Question26: True or False: You can resize a Virtual Warehouse while queries are running.

Question27: How a Snowpipe charges calculated?

Question28: What is the most granular object that the Time Travel retention period can be defined on?

Question29: True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

Question30: True or False: Once created, a micro-partition will never be changed.

Question31: Which of the following items does the Cloud services Layer manage? Choose 4 answers

Question32: Which of the following statements are true of Snowflake data loading? Choose 3 answers

Question33: What happens when a Data Provider revokes privileges to a Share on an object in their source database?

Question34: When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Question35: Which of the following statements would be used to export/unload data from Snowflake?

Question36: Which of the following roles is recommended to be used to create and manage users and roles?

Question37: True or False: A Virtual Warehouse can be resized while suspended.

Question38: True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Question39: Which of the following statements about data sharing are true? choose 2 answers

Question40: True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

Question41: True or False: Users are able to see the result sets of queries executed by other users that share their same role.

Question42: Which are true of Snowflake roles?

Question43: To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Question44: What command is used to load files into an Internal Stage within Snowflake? Select one.

Question45: When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Question46: True or False: The COPY command must specify a File Format in order to execute.

Question47: What is the minimum Snowflake edition that provides data sharing?

Question48: What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Question49: True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

Question50: Which of the following statements is true of Snowflake?

Question51: True or False: A single database can exist in more than one Snowflake account.

Question52: True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

Question53: True or False: Snowflake charges additional fees to Data providers for each share they create.

Question54: True or False: Pipes can be suspended and resumed.

Question55: When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved: